Quản lý website giới thiệu và bán điện thoại di động ASP.net
19.284 lượt xem;
- phongcach.aspx.cs
- project /
1 using System;
2 using System.Collections;
3 using System.Configuration;
4 using System.Data;
5 using System.Linq;
6 using System.Web;
7 using System.Web.Security;
8 using System.Web.UI;
9 using System.Web.UI.HtmlControls;
10 using System.Web.UI.WebControls;
11 using System.Web.UI.WebControls.WebParts;
12 using System.Xml.Linq;
13 using SiteUtils;
14 using System.Data.OleDb;
15 public partial class Default2 : System.Web.UI.Page
16 {
17 GioHangData gh;
18 protected void Page_Load(object sender, EventArgs e)
19 {
20 ado.ketNoi();
21 string query = "Select*,'chitiet.aspx?tensp='+tensp as chitiet from tblsanpham where phongcach='" + Request.QueryString.Get(0) + "'";
22 OleDbDataAdapter adapter = new OleDbDataAdapter(query, ado.con);
23 DataSet dataset = new DataSet();
24 adapter.Fill(dataset);
25 clp1.PageSize = 12;
26 clp1.DataSource = dataset.Tables[0].DefaultView;
27 clp1.BindToControl = DataList1;
28 DataList1.DataSource = clp1.DataSourcePaged;
29 }
30 protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
31 {
32 ado.ketNoi();
33 Label lbg = (Label)DataList1.Items[DataList1.SelectedIndex].FindControl("Label10");
34 HyperLink hy = (HyperLink)DataList1.Items[DataList1.SelectedIndex].FindControl("HyperLink1");
35
36
37 lbg.Visible = true;
38 gh = new GioHangData();
39 DataTable tb;
40 if (Session["GioHang"] == null)
41 tb = gh.setTable();
42 else
43 tb = (DataTable)Session["GioHang"];
44 string query = "select * from tblSanPham where masp='" + hy.Text + "'";
45
46 OleDbDataAdapter da = new OleDbDataAdapter(query, ado.con);
47 DataTable dt = new DataTable();
48 da.Fill(dt);
49 foreach (DataRow dr in dt.Rows)
50 {
51 tb = gh.dienVaoBang(tb, dr[10].ToString(), dr["TenSP"].ToString(), 1, Convert.ToDouble(dr["Gia"]), dr["masp"].ToString());
52 Session["GioHang"] = tb;
53
54 }
55 }
56 }
2 using System.Collections;
3 using System.Configuration;
4 using System.Data;
5 using System.Linq;
6 using System.Web;
7 using System.Web.Security;
8 using System.Web.UI;
9 using System.Web.UI.HtmlControls;
10 using System.Web.UI.WebControls;
11 using System.Web.UI.WebControls.WebParts;
12 using System.Xml.Linq;
13 using SiteUtils;
14 using System.Data.OleDb;
15 public partial class Default2 : System.Web.UI.Page
16 {
17 GioHangData gh;
18 protected void Page_Load(object sender, EventArgs e)
19 {
20 ado.ketNoi();
21 string query = "Select*,'chitiet.aspx?tensp='+tensp as chitiet from tblsanpham where phongcach='" + Request.QueryString.Get(0) + "'";
22 OleDbDataAdapter adapter = new OleDbDataAdapter(query, ado.con);
23 DataSet dataset = new DataSet();
24 adapter.Fill(dataset);
25 clp1.PageSize = 12;
26 clp1.DataSource = dataset.Tables[0].DefaultView;
27 clp1.BindToControl = DataList1;
28 DataList1.DataSource = clp1.DataSourcePaged;
29 }
30 protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
31 {
32 ado.ketNoi();
33 Label lbg = (Label)DataList1.Items[DataList1.SelectedIndex].FindControl("Label10");
34 HyperLink hy = (HyperLink)DataList1.Items[DataList1.SelectedIndex].FindControl("HyperLink1");
35
36
37 lbg.Visible = true;
38 gh = new GioHangData();
39 DataTable tb;
40 if (Session["GioHang"] == null)
41 tb = gh.setTable();
42 else
43 tb = (DataTable)Session["GioHang"];
44 string query = "select * from tblSanPham where masp='" + hy.Text + "'";
45
46 OleDbDataAdapter da = new OleDbDataAdapter(query, ado.con);
47 DataTable dt = new DataTable();
48 da.Fill(dt);
49 foreach (DataRow dr in dt.Rows)
50 {
51 tb = gh.dienVaoBang(tb, dr[10].ToString(), dr["TenSP"].ToString(), 1, Convert.ToDouble(dr["Gia"]), dr["masp"].ToString());
52 Session["GioHang"] = tb;
53
54 }
55 }
56 }